package com.aaa.home.dao;

import com.aaa.common.entity.AclPermission;
import com.aaa.common.entity.home.EduCourse;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author ：Mickey
 * @date ：Created in 2022/12/10 11:32
 * @description：
 * @modified By：
 * @version:
 */
public interface TbZoneCourseDao extends BaseMapper<EduCourse> {
    /**
     * 根据专区id查询专区课程
     * @return
     */
    @Select(value = "select c.* from tb_zone z join tb_zone_course zc on z.id=zc.zone_id join" +
            " edu_course c on zc.course_id = c.id where z.id = #{zoneId}")
    public List<EduCourse> selectByZoneid(String zoneId);
}
